﻿/********************************************************************************************************************
* Author:	Aristidis Mihail																						*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_category_add_moderator" that adds		*
*			a moderator to a category.																				*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_category_add_moderator]
	@userId bigint,
	@categoryId bigint
AS


	INSERT INTO [Category-Moderator]
	VALUES (@categoryId,@userId)

RETURN 0